﻿CREATE PROCEDURE [dbo].[proc_Department_GetID]
	(
		@UserName nvarchar(50),
		@DepartmentId int output
	)
AS
	Set @DepartmentId=(Select DepartmentId from Employee Where UserName=@UserName)
	--Select @DepartmentId=Isnull(DepartmentId,0) from Employee Where UserName=@UserName
	RETURN @DepartmentId
